iLoADER

HOME

Data Transformation examples

The Data Transformation function allows you to perform data engineering within iLoader. You can perform a multitude of tasks from the Data Transformation script file, including:

  • Parametric Remap
  • Quantile Remap
  • Decode Remap
  • Create Dynamic Fields
  • Numeric Remap
  • Functions Remap

The following example creates an unindexed expression which links the Forename and Surname columns.

Note: Columns are indexed automatically, to create an unindexed column add a 'U' at the beginning of the code.

UEXPRESSION [test].[person] , UFullName , {[Forename] + ' ' + [Surname]}

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice